<?php include("cabeca.php");?>
<p>
Busca por G&ecirc;nero:
<form runat="server" method="post" action="listar_filmes.php">
<?php
	include("connection.php");
	$query = "SELECT * FROM  `filme_genero`";
	$result = mysql_query($query);
	
	echo "<select name='genero'>";
	while ($row = mysql_fetch_array($result)) {
		echo "<option value='".$row['Genero']."' > ".$row['Genero']."</option>";
	}
	echo "</select>";
	
	echo "<input type='submit' value='Buscar' />";

	
	mysql_close($conn);
?>
</form>
</p>
<br /><br />
<p>
Buscar por nome:
<form runat="server" method="post" action="listar_filmes.php">
<input type="text" name="nome" /> <input type="submit" value="Buscar..." />
</form>
</p>

<?php include("pe.php");?>